Mini Project


Introduction to the project

Everyone has been affected by the COVID-19 pandemic in some manner or the other over the past two and a half years. Oil and gas become a pertinent factor for our study of Alberta because it is one of the greatest contributors to Alberta's GDP.

Alberta produces the majority of Canada's oil, therefore research into the oil and gas business is done to better understand how the province is affected during this pandemic.


Basic Info

Made By: - Swarnim Khosla

Topic: - Impact of COVID-19 on Alberta from Oil Price perspective.

Dataset Responsibility: - Gross Revenue, Net Revenue and Royalty paid to the Albertan government by Alberta's Oil and Gas companies. International prices of Oil price per barrel comparison with Gross Revenues of Alberta's Oil and Gas companies.

Note: - Visualisations at the end.

Skills demonstarted in the project: - Data Cleansing in Python (Pandas, Plotly, Numpy)


In the next section, The following Data Cleaning steps were taken: -

Data Sourcing and Data Cleansing consists of around 80% of the code. The rest 20% of the code is dedicated to plotting the graph.

For plotting the graph, Python's Plotly was used.

A line graph is made above depicting the changes in gross revenue and net revenue of Oil and Gas Industries with respect to time. The amount of Royalty paid by the Oil and Gas industry to the Albertan government is also shown.

The Line graph is divided into 3 time periods: -

1) Pre Pandemic (2016-2019) 2) COVID-19 Pandemic (2019-2020) 3) Post Pandemic (2020-2021)

The above Oil Recovery graph was made with the data which was sourced/extracted from of 1 csv and 6 Excel files. The irrelevant data was deleted from the DataFrame and only the useful columns were kept.

As we can observe from the graph, The gross revenue earned by Oil and Gas had steadily been increasing during pre pandemic times.

Key takeaways:

1) COVID-19 pandemic hit on revenues 2) High rebound at 2020-2021